<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsUKS" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="p301ConnString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="p301ConnString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.p301.Properties.Settings.GlobalReference.Default.p301ConnString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taAdr" GeneratorDataComponentClassName="taAdr" Name="dtAdr" UserDataComponentName="taAdr">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_adr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [b_adr] WHERE (([K_ADR] = @Original_K_ADR))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_ADR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ADR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [b_adr] ([A_OBL], [A_GOROD], [A_RN], [A_DOM], [A_KORP], [A_KV], [K_RN_G], [K_UL], [N_TEL]) VALUES (@A_OBL, @A_GOROD, @A_RN, @A_DOM, @A_KORP, @A_KV, @K_RN_G, @K_UL, @N_TEL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_OBL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_OBL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_GOROD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_GOROD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_RN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_RN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@A_DOM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="A_DOM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_KORP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_KORP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@A_KV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="A_KV" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RN_G" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RN_G" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_TEL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_TEL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>select 
b_adr.K_ADR,
b_adr.A_OBL,
b_adr.A_GOROD,
b_adr.A_RN,
b_adr.A_DOM,
b_adr.A_KORP,
b_adr.A_KV,
b_adr.K_RN_G,
b_adr.K_UL,
b_adr.N_TEL
from b_adr
where K_ADR = @PK_ADR</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="PK_ADR" ColumnName="K_ADR" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PK_ADR" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_ADR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [b_adr] SET [A_OBL] = @A_OBL, [A_GOROD] = @A_GOROD, [A_RN] = @A_RN, [A_DOM] = @A_DOM, [A_KORP] = @A_KORP, [A_KV] = @A_KV, [K_RN_G] = @K_RN_G, [K_UL] = @K_UL, [N_TEL] = @N_TEL WHERE (([K_ADR] = @Original_K_ADR))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_OBL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_OBL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_GOROD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_GOROD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_RN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_RN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@A_DOM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="A_DOM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_KORP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_KORP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@A_KV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="A_KV" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RN_G" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RN_G" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_TEL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_TEL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_ADR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ADR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_ADR" DataSetColumn="K_ADR" />
              <Mapping SourceColumn="A_OBL" DataSetColumn="A_OBL" />
              <Mapping SourceColumn="A_GOROD" DataSetColumn="A_GOROD" />
              <Mapping SourceColumn="A_RN" DataSetColumn="A_RN" />
              <Mapping SourceColumn="A_DOM" DataSetColumn="A_DOM" />
              <Mapping SourceColumn="A_KORP" DataSetColumn="A_KORP" />
              <Mapping SourceColumn="A_KV" DataSetColumn="A_KV" />
              <Mapping SourceColumn="K_RN_G" DataSetColumn="K_RN_G" />
              <Mapping SourceColumn="K_UL" DataSetColumn="K_UL" />
              <Mapping SourceColumn="N_TEL" DataSetColumn="N_TEL" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taUKS" GeneratorDataComponentClassName="taUKS" Name="dtUKS" UserDataComponentName="taUKS">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_uks" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [b_uks] WHERE (([K_UKS] = @Original_K_UKS))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [b_uks] ([NPP_UKS], [D_DZ], [K_ZAN], [K_ADR], [K_RAB], [K_INF_CENTR], [C_PO], [N_ORG_NAPRAVIL], [K_SP], [C_GOD_SP], [F_DETI_NET], [K_PRICH], [K_PRICH_UR]) VALUES (@NPP_UKS, @D_DZ, @K_ZAN, @K_ADR, @K_RAB, @K_INF_CENTR, @C_PO, @N_ORG_NAPRAVIL, @K_SP, @C_GOD_SP, @F_DETI_NET, @K_PRICH, @K_PRICH_UR)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NPP_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NPP_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_DZ" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_DZ" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_ZAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ZAN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_ADR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ADR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RAB" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_INF_CENTR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_INF_CENTR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@C_PO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="C_PO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_ORG_NAPRAVIL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_ORG_NAPRAVIL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@C_GOD_SP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="C_GOD_SP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_DETI_NET" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_DETI_NET" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PRICH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PRICH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PRICH_UR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PRICH_UR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     NPP_UKS, D_DZ, K_ZAN, K_ADR, K_RAB, K_INF_CENTR, C_PO, N_ORG_NAPRAVIL, K_SP, C_GOD_SP, F_DETI_NET, K_PRICH, K_PRICH_UR, K_UKS, 
                      LTRIM(STR(NPP_UKS)) + ' - ' + LTRIM(STR(YEAR(D_DZ))) AS NPP_UKSyear, YEAR(GETDATE()) - C_GOD_SP AS C_LET_SP
FROM         b_uks
WHERE     (K_UKS = @PK_UKS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="PK_UKS" ColumnName="K_UKS" DataSourceName="p301.dbo.b_uks" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PK_UKS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [b_uks] SET [NPP_UKS] = @NPP_UKS, [D_DZ] = @D_DZ, [K_ZAN] = @K_ZAN, [K_ADR] = @K_ADR, [K_RAB] = @K_RAB, [K_INF_CENTR] = @K_INF_CENTR, [C_PO] = @C_PO, [N_ORG_NAPRAVIL] = @N_ORG_NAPRAVIL, [K_SP] = @K_SP, [C_GOD_SP] = @C_GOD_SP, [F_DETI_NET] = @F_DETI_NET, [K_PRICH] = @K_PRICH, [K_PRICH_UR] = @K_PRICH_UR WHERE (([K_UKS] = @Original_K_UKS))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NPP_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NPP_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_DZ" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_DZ" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_ZAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ZAN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_ADR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ADR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RAB" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_INF_CENTR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_INF_CENTR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@C_PO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="C_PO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_ORG_NAPRAVIL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_ORG_NAPRAVIL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@C_GOD_SP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="C_GOD_SP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_DETI_NET" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_DETI_NET" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PRICH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PRICH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PRICH_UR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PRICH_UR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_UKS" DataSetColumn="K_UKS" />
              <Mapping SourceColumn="NPP_UKS" DataSetColumn="NPP_UKS" />
              <Mapping SourceColumn="D_DZ" DataSetColumn="D_DZ" />
              <Mapping SourceColumn="K_ZAN" DataSetColumn="K_ZAN" />
              <Mapping SourceColumn="K_ADR" DataSetColumn="K_ADR" />
              <Mapping SourceColumn="K_RAB" DataSetColumn="K_RAB" />
              <Mapping SourceColumn="K_INF_CENTR" DataSetColumn="K_INF_CENTR" />
              <Mapping SourceColumn="C_PO" DataSetColumn="C_PO" />
              <Mapping SourceColumn="N_ORG_NAPRAVIL" DataSetColumn="N_ORG_NAPRAVIL" />
              <Mapping SourceColumn="K_SP" DataSetColumn="K_SP" />
              <Mapping SourceColumn="C_GOD_SP" DataSetColumn="C_GOD_SP" />
              <Mapping SourceColumn="F_DETI_NET" DataSetColumn="F_DETI_NET" />
              <Mapping SourceColumn="K_PRICH" DataSetColumn="K_PRICH" />
              <Mapping SourceColumn="K_PRICH_UR" DataSetColumn="K_PRICH_UR" />
              <Mapping SourceColumn="NPP_UKSyear" DataSetColumn="NPP_UKSyear" />
              <Mapping SourceColumn="C_LET_SP" DataSetColumn="C_LET_SP" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taUksKatSem" GeneratorDataComponentClassName="taUksKatSem" Name="dtUksKatSem" UserDataComponentName="taUksKatSem">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.sv_uks_kat_sem" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [sv_uks_kat_sem] WHERE (([K_UKS_KAT_SEM] = @Original_K_UKS_KAT_SEM))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS_KAT_SEM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS_KAT_SEM" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [sv_uks_kat_sem] ([K_UKS], [K_KAT_SEM], [F_OTCHET]) VALUES (@K_UKS, @K_KAT_SEM, @F_OTCHET)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KAT_SEM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KAT_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_OTCHET" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_OTCHET" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     K_UKS_KAT_SEM, K_UKS, K_KAT_SEM, F_OTCHET
FROM         sv_uks_kat_sem
WHERE     (K_UKS = @pK_UKS)
ORDER BY F_OTCHET DESC, K_KAT_SEM</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_UKS" ColumnName="K_UKS" DataSourceName="p301.dbo.sv_uks_kat_sem" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_UKS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [sv_uks_kat_sem] SET [K_UKS] = @K_UKS, [K_KAT_SEM] = @K_KAT_SEM, [F_OTCHET] = @F_OTCHET WHERE (([K_UKS_KAT_SEM] = @Original_K_UKS_KAT_SEM))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KAT_SEM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KAT_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_OTCHET" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_OTCHET" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS_KAT_SEM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS_KAT_SEM" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_UKS_KAT_SEM" DataSetColumn="K_UKS_KAT_SEM" />
              <Mapping SourceColumn="K_UKS" DataSetColumn="K_UKS" />
              <Mapping SourceColumn="K_KAT_SEM" DataSetColumn="K_KAT_SEM" />
              <Mapping SourceColumn="F_OTCHET" DataSetColumn="F_OTCHET" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taUksKons" GeneratorDataComponentClassName="taUksKons" Name="dtUksKons" UserDataComponentName="taUksKons">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_uks_kons" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [b_uks_kons] WHERE (([K_UKS_KONS] = @Original_K_UKS_KONS) AND ((@IsNull_K_KPO = 1 AND [K_KPO] IS NULL) OR ([K_KPO] = @Original_K_KPO)) AND ((@IsNull_K_ZAN = 1 AND [K_ZAN] IS NULL) OR ([K_ZAN] = @Original_K_ZAN)) AND ((@IsNull_D_KONS = 1 AND [D_KONS] IS NULL) OR ([D_KONS] = @Original_D_KONS)) AND ((@IsNull_K_RAB = 1 AND [K_RAB] IS NULL) OR ([K_RAB] = @Original_K_RAB)) AND ((@IsNull_K_KONS = 1 AND [K_KONS] IS NULL) OR ([K_KONS] = @Original_K_KONS)) AND ((@IsNull_K_KLIENT = 1 AND [K_KLIENT] IS NULL) OR ([K_KLIENT] = @Original_K_KLIENT)) AND ((@IsNull_K_UKS = 1 AND [K_UKS] IS NULL) OR ([K_UKS] = @Original_K_UKS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS_KONS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_ZAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ZAN" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_ZAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ZAN" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_D_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="D_KONS" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_D_KONS" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_KONS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_RAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RAB" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_RAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RAB" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KONS" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KONS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_KLIENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KLIENT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KLIENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KLIENT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [b_uks_kons] ([K_KPO], [K_ZAN], [D_KONS], [K_RAB], [K_KONS], [K_KLIENT], [K_UKS]) VALUES (@K_KPO, @K_ZAN, @D_KONS, @K_RAB, @K_KONS, @K_KLIENT, @K_UKS);
SELECT K_UKS_KONS, K_KPO, K_ZAN, D_KONS, K_RAB, K_KONS, K_KLIENT, K_UKS FROM b_uks_kons WHERE (K_UKS_KONS = SCOPE_IDENTITY()) ORDER BY D_KONS</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_ZAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ZAN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_KONS" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RAB" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KLIENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KLIENT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     K_UKS_KONS, K_KPO, K_ZAN, D_KONS, K_RAB, K_KONS, K_KLIENT, K_UKS
FROM         b_uks_kons
WHERE     (K_UKS = @pK_UKS)
ORDER BY D_KONS</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_UKS" ColumnName="K_UKS" DataSourceName="p301.dbo.b_uks_kons" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_UKS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [b_uks_kons] SET [K_KPO] = @K_KPO, [K_ZAN] = @K_ZAN, [D_KONS] = @D_KONS, [K_RAB] = @K_RAB, [K_KONS] = @K_KONS, [K_KLIENT] = @K_KLIENT, [K_UKS] = @K_UKS WHERE (([K_UKS_KONS] = @Original_K_UKS_KONS) AND ((@IsNull_K_KPO = 1 AND [K_KPO] IS NULL) OR ([K_KPO] = @Original_K_KPO)) AND ((@IsNull_K_ZAN = 1 AND [K_ZAN] IS NULL) OR ([K_ZAN] = @Original_K_ZAN)) AND ((@IsNull_D_KONS = 1 AND [D_KONS] IS NULL) OR ([D_KONS] = @Original_D_KONS)) AND ((@IsNull_K_RAB = 1 AND [K_RAB] IS NULL) OR ([K_RAB] = @Original_K_RAB)) AND ((@IsNull_K_KONS = 1 AND [K_KONS] IS NULL) OR ([K_KONS] = @Original_K_KONS)) AND ((@IsNull_K_KLIENT = 1 AND [K_KLIENT] IS NULL) OR ([K_KLIENT] = @Original_K_KLIENT)) AND ((@IsNull_K_UKS = 1 AND [K_UKS] IS NULL) OR ([K_UKS] = @Original_K_UKS)));
SELECT K_UKS_KONS, K_KPO, K_ZAN, D_KONS, K_RAB, K_KONS, K_KLIENT, K_UKS FROM b_uks_kons WHERE (K_UKS_KONS = @K_UKS_KONS) ORDER BY D_KONS</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_ZAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ZAN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_KONS" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RAB" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KLIENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KLIENT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS_KONS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_ZAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ZAN" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_ZAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ZAN" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_D_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="D_KONS" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_D_KONS" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_KONS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_RAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RAB" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_RAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RAB" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KONS" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KONS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_KLIENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KLIENT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KLIENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KLIENT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="K_UKS_KONS" ColumnName="K_UKS_KONS" DataSourceName="p301.dbo.b_uks_kons" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@K_UKS_KONS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_UKS_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_UKS_KONS" DataSetColumn="K_UKS_KONS" />
              <Mapping SourceColumn="K_KPO" DataSetColumn="K_KPO" />
              <Mapping SourceColumn="K_ZAN" DataSetColumn="K_ZAN" />
              <Mapping SourceColumn="D_KONS" DataSetColumn="D_KONS" />
              <Mapping SourceColumn="K_KONS" DataSetColumn="K_KONS" />
              <Mapping SourceColumn="K_RAB" DataSetColumn="K_RAB" />
              <Mapping SourceColumn="K_KLIENT" DataSetColumn="K_KLIENT" />
              <Mapping SourceColumn="K_UKS" DataSetColumn="K_UKS" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taUksPatr" GeneratorDataComponentClassName="taUksPatr" Name="dtUksPatr" UserDataComponentName="taUksPatr">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_uks_patr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [b_uks_patr] WHERE (([K_UKS_PATR] = @Original_K_UKS_PATR))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS_PATR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS_PATR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [b_uks_patr] ([K_UKS], [D_NACH], [D_OKON]) VALUES (@K_UKS, @D_NACH, @D_OKON)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_NACH" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_NACH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_OKON" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_OKON" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     K_UKS, D_NACH, D_OKON, K_UKS_PATR, dbo.PrimPatr(D_NACH, D_OKON) AS N_PRIM
FROM         b_uks_patr
WHERE     (K_UKS = @pK_UKS)
ORDER BY D_NACH</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_UKS" ColumnName="K_UKS" DataSourceName="p301.dbo.b_uks_patr" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_UKS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [b_uks_patr] SET [K_UKS] = @K_UKS, [D_NACH] = @D_NACH, [D_OKON] = @D_OKON WHERE (([K_UKS_PATR] = @Original_K_UKS_PATR))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_NACH" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_NACH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_OKON" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_OKON" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS_PATR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS_PATR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="D_NACH" DataSetColumn="D_NACH" />
              <Mapping SourceColumn="D_OKON" DataSetColumn="D_OKON" />
              <Mapping SourceColumn="K_UKS" DataSetColumn="K_UKS" />
              <Mapping SourceColumn="K_UKS_PATR" DataSetColumn="K_UKS_PATR" />
              <Mapping SourceColumn="N_PRIM" DataSetColumn="N_PRIM" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taUksChelder" GeneratorDataComponentClassName="taUksChelder" Name="dtUksChelder" UserDataComponentName="taUksChelder">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_uks_chelder" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [b_uks_chelder] WHERE (([K_UKS_CHELDER] = @Original_K_UKS_CHELDER))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS_CHELDER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS_CHELDER" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [b_uks_chelder] ([K_UKS], [D_NACH], [D_OKON]) VALUES (@K_UKS, @D_NACH, @D_OKON)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_NACH" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_NACH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_OKON" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_OKON" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     K_UKS, D_NACH, D_OKON, K_UKS_CHELDER, dbo.PrimPatr(D_NACH, D_OKON) AS N_PRIM
FROM         b_uks_chelder
WHERE     (K_UKS = @pK_UKS)
ORDER BY D_NACH</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_UKS" ColumnName="K_UKS" DataSourceName="p301.dbo.b_uks_chelder" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_UKS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [b_uks_chelder] SET [K_UKS] = @K_UKS, [D_NACH] = @D_NACH, [D_OKON] = @D_OKON WHERE (([K_UKS_CHELDER] = @Original_K_UKS_CHELDER))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_NACH" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_NACH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_OKON" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_OKON" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_UKS_CHELDER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS_CHELDER" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="D_NACH" DataSetColumn="D_NACH" />
              <Mapping SourceColumn="D_OKON" DataSetColumn="D_OKON" />
              <Mapping SourceColumn="K_UKS" DataSetColumn="K_UKS" />
              <Mapping SourceColumn="K_UKS_CHELDER" DataSetColumn="K_UKS_CHELDER" />
              <Mapping SourceColumn="N_PRIM" DataSetColumn="N_PRIM" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taSostavSemyiUks" GeneratorDataComponentClassName="taSostavSemyiUks" Name="dtSostavSemyiUks" UserDataComponentName="taSostavSemyiUks">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_sostav_semyi_uks" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [b_sostav_semyi_uks] WHERE (([K_SOSTAV_SEMYI] = @Original_K_SOSTAV_SEMYI))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_SOSTAV_SEMYI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SOSTAV_SEMYI" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [b_sostav_semyi_uks] ([K_UKS], [N_FA], [N_IM], [N_OT], [GOD_R], [K_RODSTV_OTN], [N_PRIM], [K_POL]) VALUES (@K_UKS, @N_FA, @N_IM, @N_OT, @GOD_R, @K_RODSTV_OTN, @N_PRIM, @K_POL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_FA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_FA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_IM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_IM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_OT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_OT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GOD_R" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GOD_R" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RODSTV_OTN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RODSTV_OTN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_PRIM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_PRIM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@K_POL" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="K_POL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     K_SOSTAV_SEMYI, K_UKS, N_FA, N_IM, N_OT, GOD_R, K_RODSTV_OTN, N_PRIM, K_POL, YEAR(GETDATE()) - GOD_R AS C_LET
FROM         b_sostav_semyi_uks
WHERE     (K_UKS = @pK_UKS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_UKS" ColumnName="K_UKS" DataSourceName="p301.dbo.b_sostav_semyi_uks" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_UKS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [b_sostav_semyi_uks] SET [K_UKS] = @K_UKS, [N_FA] = @N_FA, [N_IM] = @N_IM, [N_OT] = @N_OT, [GOD_R] = @GOD_R, [K_RODSTV_OTN] = @K_RODSTV_OTN, [N_PRIM] = @N_PRIM, [K_POL] = @K_POL WHERE (([K_SOSTAV_SEMYI] = @Original_K_SOSTAV_SEMYI))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_FA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_FA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_IM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_IM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_OT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_OT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GOD_R" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GOD_R" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RODSTV_OTN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RODSTV_OTN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_PRIM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_PRIM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@K_POL" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="K_POL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_SOSTAV_SEMYI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SOSTAV_SEMYI" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_SOSTAV_SEMYI" DataSetColumn="K_SOSTAV_SEMYI" />
              <Mapping SourceColumn="K_UKS" DataSetColumn="K_UKS" />
              <Mapping SourceColumn="N_FA" DataSetColumn="N_FA" />
              <Mapping SourceColumn="N_IM" DataSetColumn="N_IM" />
              <Mapping SourceColumn="N_OT" DataSetColumn="N_OT" />
              <Mapping SourceColumn="GOD_R" DataSetColumn="GOD_R" />
              <Mapping SourceColumn="K_RODSTV_OTN" DataSetColumn="K_RODSTV_OTN" />
              <Mapping SourceColumn="N_PRIM" DataSetColumn="N_PRIM" />
              <Mapping SourceColumn="K_POL" DataSetColumn="K_POL" />
              <Mapping SourceColumn="C_LET" DataSetColumn="C_LET" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKlient" GeneratorDataComponentClassName="taKlient" Name="dtKlient" UserDataComponentName="taKlient">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_klient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [b_klient] WHERE (([K_KLIENT] = @Original_K_KLIENT))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KLIENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KLIENT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [b_klient] ([K_UKS], [F_INITSIATOR], [K_RODSTV_OTN], [GOD_R], [K_OBR], [K_SPEC], [K_SP], [K_SOCSTAT], [N_FA], [N_IM], [N_OT], [K_POL]) VALUES (@K_UKS, @F_INITSIATOR, @K_RODSTV_OTN, @GOD_R, @K_OBR, @K_SPEC, @K_SP, @K_SOCSTAT, @N_FA, @N_IM, @N_OT, @K_POL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_INITSIATOR" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_INITSIATOR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RODSTV_OTN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RODSTV_OTN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GOD_R" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GOD_R" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_OBR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_OBR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SPEC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SPEC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SOCSTAT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SOCSTAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@N_FA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="N_FA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@N_IM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="N_IM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@N_OT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="N_OT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@K_POL" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="K_POL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     K_KLIENT, K_UKS, F_INITSIATOR, K_RODSTV_OTN, GOD_R, K_OBR, K_SPEC, K_SP, K_SOCSTAT, YEAR(GETDATE()) - GOD_R AS C_LET, N_FA, N_IM, 
                      N_OT, K_POL, dbo.N_FIO(N_FA, N_IM, N_OT) AS N_FIO
FROM         b_klient
WHERE     (K_UKS = @pK_UKS)
ORDER BY F_INITSIATOR DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_UKS" ColumnName="K_UKS" DataSourceName="p301.dbo.b_klient" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_UKS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [b_klient] SET [K_UKS] = @K_UKS, [F_INITSIATOR] = @F_INITSIATOR, [K_RODSTV_OTN] = @K_RODSTV_OTN, [GOD_R] = @GOD_R, [K_OBR] = @K_OBR, [K_SPEC] = @K_SPEC, [K_SP] = @K_SP, [K_SOCSTAT] = @K_SOCSTAT, [N_FA] = @N_FA, [N_IM] = @N_IM, [N_OT] = @N_OT, [K_POL] = @K_POL WHERE (([K_KLIENT] = @Original_K_KLIENT))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_INITSIATOR" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_INITSIATOR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RODSTV_OTN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RODSTV_OTN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GOD_R" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GOD_R" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_OBR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_OBR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SPEC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SPEC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SOCSTAT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SOCSTAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@N_FA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="N_FA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@N_IM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="N_IM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@N_OT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="N_OT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@K_POL" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="K_POL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KLIENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KLIENT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_KLIENT" DataSetColumn="K_KLIENT" />
              <Mapping SourceColumn="K_UKS" DataSetColumn="K_UKS" />
              <Mapping SourceColumn="F_INITSIATOR" DataSetColumn="F_INITSIATOR" />
              <Mapping SourceColumn="K_RODSTV_OTN" DataSetColumn="K_RODSTV_OTN" />
              <Mapping SourceColumn="GOD_R" DataSetColumn="GOD_R" />
              <Mapping SourceColumn="K_OBR" DataSetColumn="K_OBR" />
              <Mapping SourceColumn="K_SPEC" DataSetColumn="K_SPEC" />
              <Mapping SourceColumn="K_SP" DataSetColumn="K_SP" />
              <Mapping SourceColumn="K_SOCSTAT" DataSetColumn="K_SOCSTAT" />
              <Mapping SourceColumn="C_LET" DataSetColumn="C_LET" />
              <Mapping SourceColumn="N_FA" DataSetColumn="N_FA" />
              <Mapping SourceColumn="N_IM" DataSetColumn="N_IM" />
              <Mapping SourceColumn="N_OT" DataSetColumn="N_OT" />
              <Mapping SourceColumn="K_POL" DataSetColumn="K_POL" />
              <Mapping SourceColumn="N_FIO" DataSetColumn="N_FIO" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKpoSpis" GeneratorDataComponentClassName="taKpoSpis" Name="dtKpoSpis" UserDataComponentName="taKpoSpis">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.v_kpo_spis" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     v_kpo_spis.*
FROM         v_kpo_spis
WHERE     (K_UKS = @pK_UKS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_UKS" ColumnName="K_UKS" DataSourceName="p301.dbo.v_kpo_spis" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_UKS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_KPO" DataSetColumn="K_KPO" />
              <Mapping SourceColumn="K_UKS" DataSetColumn="K_UKS" />
              <Mapping SourceColumn="NPP_KPO" DataSetColumn="NPP_KPO" />
              <Mapping SourceColumn="D_OBRASCH" DataSetColumn="D_OBRASCH" />
              <Mapping SourceColumn="N_FIO" DataSetColumn="N_FIO" />
              <Mapping SourceColumn="N_OBRASCH" DataSetColumn="N_OBRASCH" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsUKS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsUKS" msprop:Generator_DataSetName="dsUKS">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dtAdr" msprop:Generator_UserTableName="dtAdr" msprop:Generator_RowDeletedName="dtAdrRowDeleted" msprop:Generator_RowChangedName="dtAdrRowChanged" msprop:Generator_RowClassName="dtAdrRow" msprop:Generator_RowChangingName="dtAdrRowChanging" msprop:Generator_RowEvArgName="dtAdrRowChangeEvent" msprop:Generator_RowEvHandlerName="dtAdrRowChangeEventHandler" msprop:Generator_TableClassName="dtAdrDataTable" msprop:Generator_TableVarName="tabledtAdr" msprop:Generator_RowDeletingName="dtAdrRowDeleting" msprop:Generator_TablePropName="dtAdr">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_ADR" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_ADR" msprop:Generator_ColumnVarNameInTable="columnK_ADR" msprop:Generator_ColumnPropNameInRow="K_ADR" msprop:Generator_ColumnPropNameInTable="K_ADRColumn" type="xs:int" />
              <xs:element name="A_OBL" msprop:Generator_UserColumnName="A_OBL" msprop:Generator_ColumnVarNameInTable="columnA_OBL" msprop:Generator_ColumnPropNameInRow="A_OBL" msprop:Generator_ColumnPropNameInTable="A_OBLColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="A_GOROD" msprop:Generator_UserColumnName="A_GOROD" msprop:Generator_ColumnVarNameInTable="columnA_GOROD" msprop:Generator_ColumnPropNameInRow="A_GOROD" msprop:Generator_ColumnPropNameInTable="A_GORODColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="A_RN" msprop:Generator_UserColumnName="A_RN" msprop:Generator_ColumnVarNameInTable="columnA_RN" msprop:Generator_ColumnPropNameInRow="A_RN" msprop:Generator_ColumnPropNameInTable="A_RNColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="A_DOM" msprop:Generator_UserColumnName="A_DOM" msprop:Generator_ColumnVarNameInTable="columnA_DOM" msprop:Generator_ColumnPropNameInRow="A_DOM" msprop:Generator_ColumnPropNameInTable="A_DOMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="A_KORP" msprop:Generator_UserColumnName="A_KORP" msprop:Generator_ColumnVarNameInTable="columnA_KORP" msprop:Generator_ColumnPropNameInRow="A_KORP" msprop:Generator_ColumnPropNameInTable="A_KORPColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="A_KV" msprop:Generator_UserColumnName="A_KV" msprop:Generator_ColumnVarNameInTable="columnA_KV" msprop:Generator_ColumnPropNameInRow="A_KV" msprop:Generator_ColumnPropNameInTable="A_KVColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_RN_G" msprop:Generator_UserColumnName="K_RN_G" msprop:Generator_ColumnVarNameInTable="columnK_RN_G" msprop:Generator_ColumnPropNameInRow="K_RN_G" msprop:Generator_ColumnPropNameInTable="K_RN_GColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_UL" msprop:Generator_UserColumnName="K_UL" msprop:Generator_ColumnVarNameInTable="columnK_UL" msprop:Generator_ColumnPropNameInRow="K_UL" msprop:Generator_ColumnPropNameInTable="K_ULColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_TEL" msprop:Generator_UserColumnName="N_TEL" msprop:Generator_ColumnVarNameInTable="columnN_TEL" msprop:Generator_ColumnPropNameInRow="N_TEL" msprop:Generator_ColumnPropNameInTable="N_TELColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtUKS" msprop:Generator_UserTableName="dtUKS" msprop:Generator_RowDeletedName="dtUKSRowDeleted" msprop:Generator_RowChangedName="dtUKSRowChanged" msprop:Generator_RowClassName="dtUKSRow" msprop:Generator_RowChangingName="dtUKSRowChanging" msprop:Generator_RowEvArgName="dtUKSRowChangeEvent" msprop:Generator_RowEvHandlerName="dtUKSRowChangeEventHandler" msprop:Generator_TableClassName="dtUKSDataTable" msprop:Generator_TableVarName="tabledtUKS" msprop:Generator_RowDeletingName="dtUKSRowDeleting" msprop:Generator_TablePropName="dtUKS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_UKS" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_UKS" msprop:Generator_ColumnVarNameInTable="columnK_UKS" msprop:Generator_ColumnPropNameInRow="K_UKS" msprop:Generator_ColumnPropNameInTable="K_UKSColumn" type="xs:int" />
              <xs:element name="NPP_UKS" msprop:Generator_UserColumnName="NPP_UKS" msprop:Generator_ColumnVarNameInTable="columnNPP_UKS" msprop:Generator_ColumnPropNameInRow="NPP_UKS" msprop:Generator_ColumnPropNameInTable="NPP_UKSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="D_DZ" msprop:Generator_UserColumnName="D_DZ" msprop:Generator_ColumnVarNameInTable="columnD_DZ" msprop:Generator_ColumnPropNameInRow="D_DZ" msprop:Generator_ColumnPropNameInTable="D_DZColumn" type="xs:dateTime" />
              <xs:element name="K_ZAN" msprop:Generator_UserColumnName="K_ZAN" msprop:Generator_ColumnVarNameInTable="columnK_ZAN" msprop:Generator_ColumnPropNameInRow="K_ZAN" msprop:Generator_ColumnPropNameInTable="K_ZANColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_ADR" msprop:Generator_UserColumnName="K_ADR" msprop:Generator_ColumnVarNameInTable="columnK_ADR" msprop:Generator_ColumnPropNameInRow="K_ADR" msprop:Generator_ColumnPropNameInTable="K_ADRColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_RAB" msprop:Generator_UserColumnName="K_RAB" msprop:Generator_ColumnVarNameInTable="columnK_RAB" msprop:Generator_ColumnPropNameInRow="K_RAB" msprop:Generator_ColumnPropNameInTable="K_RABColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_INF_CENTR" msprop:Generator_UserColumnName="K_INF_CENTR" msprop:Generator_ColumnVarNameInTable="columnK_INF_CENTR" msprop:Generator_ColumnPropNameInRow="K_INF_CENTR" msprop:Generator_ColumnPropNameInTable="K_INF_CENTRColumn" type="xs:int" minOccurs="0" />
              <xs:element name="C_PO" msprop:Generator_UserColumnName="C_PO" msprop:Generator_ColumnVarNameInTable="columnC_PO" msprop:Generator_ColumnPropNameInRow="C_PO" msprop:Generator_ColumnPropNameInTable="C_POColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_ORG_NAPRAVIL" msprop:Generator_UserColumnName="N_ORG_NAPRAVIL" msprop:Generator_ColumnVarNameInTable="columnN_ORG_NAPRAVIL" msprop:Generator_ColumnPropNameInRow="N_ORG_NAPRAVIL" msprop:Generator_ColumnPropNameInTable="N_ORG_NAPRAVILColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="K_SP" msprop:Generator_UserColumnName="K_SP" msprop:Generator_ColumnVarNameInTable="columnK_SP" msprop:Generator_ColumnPropNameInRow="K_SP" msprop:Generator_ColumnPropNameInTable="K_SPColumn" type="xs:int" minOccurs="0" />
              <xs:element name="C_GOD_SP" msprop:Generator_UserColumnName="C_GOD_SP" msprop:Generator_ColumnVarNameInTable="columnC_GOD_SP" msprop:Generator_ColumnPropNameInRow="C_GOD_SP" msprop:Generator_ColumnPropNameInTable="C_GOD_SPColumn" type="xs:int" minOccurs="0" />
              <xs:element name="F_DETI_NET" msprop:Generator_UserColumnName="F_DETI_NET" msprop:Generator_ColumnVarNameInTable="columnF_DETI_NET" msprop:Generator_ColumnPropNameInRow="F_DETI_NET" msprop:Generator_ColumnPropNameInTable="F_DETI_NETColumn" type="xs:boolean" />
              <xs:element name="K_PRICH" msprop:Generator_UserColumnName="K_PRICH" msprop:Generator_ColumnVarNameInTable="columnK_PRICH" msprop:Generator_ColumnPropNameInRow="K_PRICH" msprop:Generator_ColumnPropNameInTable="K_PRICHColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_PRICH_UR" msprop:Generator_UserColumnName="K_PRICH_UR" msprop:Generator_ColumnVarNameInTable="columnK_PRICH_UR" msprop:Generator_ColumnPropNameInRow="K_PRICH_UR" msprop:Generator_ColumnPropNameInTable="K_PRICH_URColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NPP_UKSyear" msdata:ReadOnly="true" msprop:Generator_UserColumnName="NPP_UKSyear" msprop:Generator_ColumnPropNameInRow="NPP_UKSyear" msprop:Generator_ColumnVarNameInTable="columnNPP_UKSyear" msprop:Generator_ColumnPropNameInTable="NPP_UKSyearColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="23" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="C_LET_SP" msprop:Generator_UserColumnName="C_LET_SP" msprop:Generator_ColumnPropNameInRow="C_LET_SP" msprop:Generator_ColumnVarNameInTable="columnC_LET_SP" msprop:Generator_ColumnPropNameInTable="C_LET_SPColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtUksKatSem" msprop:Generator_UserTableName="dtUksKatSem" msprop:Generator_RowDeletedName="dtUksKatSemRowDeleted" msprop:Generator_RowChangedName="dtUksKatSemRowChanged" msprop:Generator_RowClassName="dtUksKatSemRow" msprop:Generator_RowChangingName="dtUksKatSemRowChanging" msprop:Generator_RowEvArgName="dtUksKatSemRowChangeEvent" msprop:Generator_RowEvHandlerName="dtUksKatSemRowChangeEventHandler" msprop:Generator_TableClassName="dtUksKatSemDataTable" msprop:Generator_TableVarName="tabledtUksKatSem" msprop:Generator_RowDeletingName="dtUksKatSemRowDeleting" msprop:Generator_TablePropName="dtUksKatSem">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_UKS_KAT_SEM" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_UKS_KAT_SEM" msprop:Generator_ColumnVarNameInTable="columnK_UKS_KAT_SEM" msprop:Generator_ColumnPropNameInRow="K_UKS_KAT_SEM" msprop:Generator_ColumnPropNameInTable="K_UKS_KAT_SEMColumn" type="xs:int" />
              <xs:element name="K_UKS" msprop:Generator_UserColumnName="K_UKS" msprop:Generator_ColumnVarNameInTable="columnK_UKS" msprop:Generator_ColumnPropNameInRow="K_UKS" msprop:Generator_ColumnPropNameInTable="K_UKSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_KAT_SEM" msprop:Generator_UserColumnName="K_KAT_SEM" msprop:Generator_ColumnVarNameInTable="columnK_KAT_SEM" msprop:Generator_ColumnPropNameInRow="K_KAT_SEM" msprop:Generator_ColumnPropNameInTable="K_KAT_SEMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="F_OTCHET" msprop:Generator_UserColumnName="F_OTCHET" msprop:Generator_ColumnVarNameInTable="columnF_OTCHET" msprop:Generator_ColumnPropNameInRow="F_OTCHET" msprop:Generator_ColumnPropNameInTable="F_OTCHETColumn" type="xs:boolean" default="false" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtUksKons" msprop:Generator_UserTableName="dtUksKons" msprop:Generator_RowDeletedName="dtUksKonsRowDeleted" msprop:Generator_RowChangedName="dtUksKonsRowChanged" msprop:Generator_RowClassName="dtUksKonsRow" msprop:Generator_RowChangingName="dtUksKonsRowChanging" msprop:Generator_RowEvArgName="dtUksKonsRowChangeEvent" msprop:Generator_RowEvHandlerName="dtUksKonsRowChangeEventHandler" msprop:Generator_TableClassName="dtUksKonsDataTable" msprop:Generator_TableVarName="tabledtUksKons" msprop:Generator_RowDeletingName="dtUksKonsRowDeleting" msprop:Generator_TablePropName="dtUksKons">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_UKS_KONS" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_UKS_KONS" msprop:Generator_ColumnVarNameInTable="columnK_UKS_KONS" msprop:Generator_ColumnPropNameInRow="K_UKS_KONS" msprop:Generator_ColumnPropNameInTable="K_UKS_KONSColumn" type="xs:int" />
              <xs:element name="K_KPO" msprop:Generator_UserColumnName="K_KPO" msprop:Generator_ColumnVarNameInTable="columnK_KPO" msprop:Generator_ColumnPropNameInRow="K_KPO" msprop:Generator_ColumnPropNameInTable="K_KPOColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_ZAN" msprop:Generator_UserColumnName="K_ZAN" msprop:Generator_ColumnVarNameInTable="columnK_ZAN" msprop:Generator_ColumnPropNameInRow="K_ZAN" msprop:Generator_ColumnPropNameInTable="K_ZANColumn" type="xs:int" default="2" minOccurs="0" />
              <xs:element name="D_KONS" msprop:Generator_UserColumnName="D_KONS" msprop:Generator_ColumnVarNameInTable="columnD_KONS" msprop:Generator_ColumnPropNameInRow="D_KONS" msprop:Generator_ColumnPropNameInTable="D_KONSColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="K_KONS" msprop:Generator_UserColumnName="K_KONS" msprop:Generator_ColumnVarNameInTable="columnK_KONS" msprop:Generator_ColumnPropNameInRow="K_KONS" msprop:Generator_ColumnPropNameInTable="K_KONSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_RAB" msprop:Generator_UserColumnName="K_RAB" msprop:Generator_ColumnVarNameInTable="columnK_RAB" msprop:Generator_ColumnPropNameInRow="K_RAB" msprop:Generator_ColumnPropNameInTable="K_RABColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_KLIENT" msprop:Generator_UserColumnName="K_KLIENT" msprop:Generator_ColumnVarNameInTable="columnK_KLIENT" msprop:Generator_ColumnPropNameInRow="K_KLIENT" msprop:Generator_ColumnPropNameInTable="K_KLIENTColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_UKS" msprop:Generator_UserColumnName="K_UKS" msprop:Generator_ColumnPropNameInRow="K_UKS" msprop:Generator_ColumnVarNameInTable="columnK_UKS" msprop:Generator_ColumnPropNameInTable="K_UKSColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtUksPatr" msprop:Generator_UserTableName="dtUksPatr" msprop:Generator_RowDeletedName="dtUksPatrRowDeleted" msprop:Generator_RowChangedName="dtUksPatrRowChanged" msprop:Generator_RowClassName="dtUksPatrRow" msprop:Generator_RowChangingName="dtUksPatrRowChanging" msprop:Generator_RowEvArgName="dtUksPatrRowChangeEvent" msprop:Generator_RowEvHandlerName="dtUksPatrRowChangeEventHandler" msprop:Generator_TableClassName="dtUksPatrDataTable" msprop:Generator_TableVarName="tabledtUksPatr" msprop:Generator_RowDeletingName="dtUksPatrRowDeleting" msprop:Generator_TablePropName="dtUksPatr">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="D_NACH" msprop:Generator_UserColumnName="D_NACH" msprop:Generator_ColumnVarNameInTable="columnD_NACH" msprop:Generator_ColumnPropNameInRow="D_NACH" msprop:Generator_ColumnPropNameInTable="D_NACHColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="D_OKON" msprop:Generator_UserColumnName="D_OKON" msprop:Generator_ColumnVarNameInTable="columnD_OKON" msprop:Generator_ColumnPropNameInRow="D_OKON" msprop:Generator_ColumnPropNameInTable="D_OKONColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="K_UKS" msprop:Generator_UserColumnName="K_UKS" msprop:Generator_ColumnPropNameInRow="K_UKS" msprop:Generator_ColumnVarNameInTable="columnK_UKS" msprop:Generator_ColumnPropNameInTable="K_UKSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_UKS_PATR" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_UKS_PATR" msprop:Generator_ColumnPropNameInRow="K_UKS_PATR" msprop:Generator_ColumnVarNameInTable="columnK_UKS_PATR" msprop:Generator_ColumnPropNameInTable="K_UKS_PATRColumn" type="xs:int" />
              <xs:element name="N_PRIM" msdata:ReadOnly="true" msprop:Generator_UserColumnName="N_PRIM" msprop:Generator_ColumnPropNameInRow="N_PRIM" msprop:Generator_ColumnVarNameInTable="columnN_PRIM" msprop:Generator_ColumnPropNameInTable="N_PRIMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1024" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtUksChelder" msprop:Generator_UserTableName="dtUksChelder" msprop:Generator_RowDeletedName="dtUksChelderRowDeleted" msprop:Generator_RowChangedName="dtUksChelderRowChanged" msprop:Generator_RowClassName="dtUksChelderRow" msprop:Generator_RowChangingName="dtUksChelderRowChanging" msprop:Generator_RowEvArgName="dtUksChelderRowChangeEvent" msprop:Generator_RowEvHandlerName="dtUksChelderRowChangeEventHandler" msprop:Generator_TableClassName="dtUksChelderDataTable" msprop:Generator_TableVarName="tabledtUksChelder" msprop:Generator_RowDeletingName="dtUksChelderRowDeleting" msprop:Generator_TablePropName="dtUksChelder">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="D_NACH" msprop:Generator_UserColumnName="D_NACH" msprop:Generator_ColumnVarNameInTable="columnD_NACH" msprop:Generator_ColumnPropNameInRow="D_NACH" msprop:Generator_ColumnPropNameInTable="D_NACHColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="D_OKON" msprop:Generator_UserColumnName="D_OKON" msprop:Generator_ColumnVarNameInTable="columnD_OKON" msprop:Generator_ColumnPropNameInRow="D_OKON" msprop:Generator_ColumnPropNameInTable="D_OKONColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="K_UKS" msprop:Generator_UserColumnName="K_UKS" msprop:Generator_ColumnPropNameInRow="K_UKS" msprop:Generator_ColumnVarNameInTable="columnK_UKS" msprop:Generator_ColumnPropNameInTable="K_UKSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_UKS_CHELDER" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_UKS_CHELDER" msprop:Generator_ColumnPropNameInRow="K_UKS_CHELDER" msprop:Generator_ColumnVarNameInTable="columnK_UKS_CHELDER" msprop:Generator_ColumnPropNameInTable="K_UKS_CHELDERColumn" type="xs:int" />
              <xs:element name="N_PRIM" msdata:ReadOnly="true" msprop:Generator_UserColumnName="N_PRIM" msprop:Generator_ColumnPropNameInRow="N_PRIM" msprop:Generator_ColumnVarNameInTable="columnN_PRIM" msprop:Generator_ColumnPropNameInTable="N_PRIMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1024" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtSostavSemyiUks" msprop:Generator_UserTableName="dtSostavSemyiUks" msprop:Generator_RowDeletedName="dtSostavSemyiUksRowDeleted" msprop:Generator_RowChangedName="dtSostavSemyiUksRowChanged" msprop:Generator_RowClassName="dtSostavSemyiUksRow" msprop:Generator_RowChangingName="dtSostavSemyiUksRowChanging" msprop:Generator_RowEvArgName="dtSostavSemyiUksRowChangeEvent" msprop:Generator_RowEvHandlerName="dtSostavSemyiUksRowChangeEventHandler" msprop:Generator_TableClassName="dtSostavSemyiUksDataTable" msprop:Generator_TableVarName="tabledtSostavSemyiUks" msprop:Generator_RowDeletingName="dtSostavSemyiUksRowDeleting" msprop:Generator_TablePropName="dtSostavSemyiUks">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_SOSTAV_SEMYI" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_SOSTAV_SEMYI" msprop:Generator_ColumnVarNameInTable="columnK_SOSTAV_SEMYI" msprop:Generator_ColumnPropNameInRow="K_SOSTAV_SEMYI" msprop:Generator_ColumnPropNameInTable="K_SOSTAV_SEMYIColumn" type="xs:int" />
              <xs:element name="K_UKS" msprop:Generator_UserColumnName="K_UKS" msprop:Generator_ColumnVarNameInTable="columnK_UKS" msprop:Generator_ColumnPropNameInRow="K_UKS" msprop:Generator_ColumnPropNameInTable="K_UKSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_FA" msprop:Generator_UserColumnName="N_FA" msprop:Generator_ColumnVarNameInTable="columnN_FA" msprop:Generator_ColumnPropNameInRow="N_FA" msprop:Generator_ColumnPropNameInTable="N_FAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="N_IM" msprop:Generator_UserColumnName="N_IM" msprop:Generator_ColumnVarNameInTable="columnN_IM" msprop:Generator_ColumnPropNameInRow="N_IM" msprop:Generator_ColumnPropNameInTable="N_IMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="N_OT" msprop:Generator_UserColumnName="N_OT" msprop:Generator_ColumnVarNameInTable="columnN_OT" msprop:Generator_ColumnPropNameInRow="N_OT" msprop:Generator_ColumnPropNameInTable="N_OTColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GOD_R" msprop:Generator_UserColumnName="GOD_R" msprop:Generator_ColumnVarNameInTable="columnGOD_R" msprop:Generator_ColumnPropNameInRow="GOD_R" msprop:Generator_ColumnPropNameInTable="GOD_RColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_RODSTV_OTN" msprop:Generator_UserColumnName="K_RODSTV_OTN" msprop:Generator_ColumnVarNameInTable="columnK_RODSTV_OTN" msprop:Generator_ColumnPropNameInRow="K_RODSTV_OTN" msprop:Generator_ColumnPropNameInTable="K_RODSTV_OTNColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_PRIM" msprop:Generator_UserColumnName="N_PRIM" msprop:Generator_ColumnVarNameInTable="columnN_PRIM" msprop:Generator_ColumnPropNameInRow="N_PRIM" msprop:Generator_ColumnPropNameInTable="N_PRIMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="K_POL" msprop:Generator_UserColumnName="K_POL" msprop:Generator_ColumnVarNameInTable="columnK_POL" msprop:Generator_ColumnPropNameInRow="K_POL" msprop:Generator_ColumnPropNameInTable="K_POLColumn" type="xs:unsignedByte" default="2" minOccurs="0" />
              <xs:element name="C_LET" msprop:Generator_UserColumnName="C_LET" msprop:Generator_ColumnVarNameInTable="columnC_LET" msprop:Generator_ColumnPropNameInRow="C_LET" msprop:Generator_ColumnPropNameInTable="C_LETColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKlient" msprop:Generator_UserTableName="dtKlient" msprop:Generator_RowDeletedName="dtKlientRowDeleted" msprop:Generator_RowChangedName="dtKlientRowChanged" msprop:Generator_RowClassName="dtKlientRow" msprop:Generator_RowChangingName="dtKlientRowChanging" msprop:Generator_RowEvArgName="dtKlientRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKlientRowChangeEventHandler" msprop:Generator_TableClassName="dtKlientDataTable" msprop:Generator_TableVarName="tabledtKlient" msprop:Generator_RowDeletingName="dtKlientRowDeleting" msprop:Generator_TablePropName="dtKlient">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_KLIENT" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_KLIENT" msprop:Generator_ColumnVarNameInTable="columnK_KLIENT" msprop:Generator_ColumnPropNameInRow="K_KLIENT" msprop:Generator_ColumnPropNameInTable="K_KLIENTColumn" type="xs:int" />
              <xs:element name="K_UKS" msprop:Generator_UserColumnName="K_UKS" msprop:Generator_ColumnVarNameInTable="columnK_UKS" msprop:Generator_ColumnPropNameInRow="K_UKS" msprop:Generator_ColumnPropNameInTable="K_UKSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="F_INITSIATOR" msprop:Generator_UserColumnName="F_INITSIATOR" msprop:Generator_ColumnVarNameInTable="columnF_INITSIATOR" msprop:Generator_ColumnPropNameInRow="F_INITSIATOR" msprop:Generator_ColumnPropNameInTable="F_INITSIATORColumn" type="xs:boolean" default="false" />
              <xs:element name="K_RODSTV_OTN" msprop:Generator_UserColumnName="K_RODSTV_OTN" msprop:Generator_ColumnVarNameInTable="columnK_RODSTV_OTN" msprop:Generator_ColumnPropNameInRow="K_RODSTV_OTN" msprop:Generator_ColumnPropNameInTable="K_RODSTV_OTNColumn" type="xs:int" minOccurs="0" />
              <xs:element name="GOD_R" msprop:Generator_UserColumnName="GOD_R" msprop:Generator_ColumnVarNameInTable="columnGOD_R" msprop:Generator_ColumnPropNameInRow="GOD_R" msprop:Generator_ColumnPropNameInTable="GOD_RColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_OBR" msprop:Generator_UserColumnName="K_OBR" msprop:Generator_ColumnVarNameInTable="columnK_OBR" msprop:Generator_ColumnPropNameInRow="K_OBR" msprop:Generator_ColumnPropNameInTable="K_OBRColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_SPEC" msprop:Generator_UserColumnName="K_SPEC" msprop:Generator_ColumnVarNameInTable="columnK_SPEC" msprop:Generator_ColumnPropNameInRow="K_SPEC" msprop:Generator_ColumnPropNameInTable="K_SPECColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_SP" msprop:Generator_UserColumnName="K_SP" msprop:Generator_ColumnVarNameInTable="columnK_SP" msprop:Generator_ColumnPropNameInRow="K_SP" msprop:Generator_ColumnPropNameInTable="K_SPColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_SOCSTAT" msprop:Generator_UserColumnName="K_SOCSTAT" msprop:Generator_ColumnVarNameInTable="columnK_SOCSTAT" msprop:Generator_ColumnPropNameInRow="K_SOCSTAT" msprop:Generator_ColumnPropNameInTable="K_SOCSTATColumn" type="xs:int" minOccurs="0" />
              <xs:element name="C_LET" msprop:Generator_UserColumnName="C_LET" msprop:Generator_ColumnVarNameInTable="columnC_LET" msprop:Generator_ColumnPropNameInRow="C_LET" msprop:Generator_ColumnPropNameInTable="C_LETColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_FA" msprop:Generator_UserColumnName="N_FA" msprop:Generator_ColumnVarNameInTable="columnN_FA" msprop:Generator_ColumnPropNameInRow="N_FA" msprop:Generator_ColumnPropNameInTable="N_FAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="N_IM" msprop:Generator_UserColumnName="N_IM" msprop:Generator_ColumnVarNameInTable="columnN_IM" msprop:Generator_ColumnPropNameInRow="N_IM" msprop:Generator_ColumnPropNameInTable="N_IMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="N_OT" msprop:Generator_UserColumnName="N_OT" msprop:Generator_ColumnVarNameInTable="columnN_OT" msprop:Generator_ColumnPropNameInRow="N_OT" msprop:Generator_ColumnPropNameInTable="N_OTColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="K_POL" msprop:Generator_UserColumnName="K_POL" msprop:Generator_ColumnVarNameInTable="columnK_POL" msprop:Generator_ColumnPropNameInRow="K_POL" msprop:Generator_ColumnPropNameInTable="K_POLColumn" type="xs:unsignedByte" default="2" minOccurs="0" />
              <xs:element name="N_FIO" msdata:ReadOnly="true" msprop:Generator_UserColumnName="N_FIO" msprop:Generator_ColumnPropNameInRow="N_FIO" msprop:Generator_ColumnVarNameInTable="columnN_FIO" msprop:Generator_ColumnPropNameInTable="N_FIOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="155" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKpoSpis" msprop:Generator_UserTableName="dtKpoSpis" msprop:Generator_RowDeletedName="dtKpoSpisRowDeleted" msprop:Generator_RowChangedName="dtKpoSpisRowChanged" msprop:Generator_RowClassName="dtKpoSpisRow" msprop:Generator_RowChangingName="dtKpoSpisRowChanging" msprop:Generator_RowEvArgName="dtKpoSpisRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKpoSpisRowChangeEventHandler" msprop:Generator_TableClassName="dtKpoSpisDataTable" msprop:Generator_TableVarName="tabledtKpoSpis" msprop:Generator_RowDeletingName="dtKpoSpisRowDeleting" msprop:Generator_TablePropName="dtKpoSpis">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_KPO" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_KPO" msprop:Generator_ColumnPropNameInRow="K_KPO" msprop:Generator_ColumnVarNameInTable="columnK_KPO" msprop:Generator_ColumnPropNameInTable="K_KPOColumn" type="xs:int" />
              <xs:element name="K_UKS" msprop:Generator_UserColumnName="K_UKS" msprop:Generator_ColumnPropNameInRow="K_UKS" msprop:Generator_ColumnVarNameInTable="columnK_UKS" msprop:Generator_ColumnPropNameInTable="K_UKSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NPP_KPO" msprop:Generator_UserColumnName="NPP_KPO" msprop:Generator_ColumnPropNameInRow="NPP_KPO" msprop:Generator_ColumnVarNameInTable="columnNPP_KPO" msprop:Generator_ColumnPropNameInTable="NPP_KPOColumn" type="xs:int" minOccurs="0" />
              <xs:element name="D_OBRASCH" msprop:Generator_UserColumnName="D_OBRASCH" msprop:Generator_ColumnPropNameInRow="D_OBRASCH" msprop:Generator_ColumnVarNameInTable="columnD_OBRASCH" msprop:Generator_ColumnPropNameInTable="D_OBRASCHColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="N_FIO" msdata:ReadOnly="true" msprop:Generator_UserColumnName="N_FIO" msprop:Generator_ColumnPropNameInRow="N_FIO" msprop:Generator_ColumnVarNameInTable="columnN_FIO" msprop:Generator_ColumnPropNameInTable="N_FIOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="155" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="N_OBRASCH" msprop:Generator_UserColumnName="N_OBRASCH" msprop:Generator_ColumnPropNameInRow="N_OBRASCH" msprop:Generator_ColumnVarNameInTable="columnN_OBRASCH" msprop:Generator_ColumnPropNameInTable="N_OBRASCHColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtAdr" />
      <xs:field xpath="mstns:K_ADR" />
    </xs:unique>
    <xs:unique name="dtUKS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtUKS" />
      <xs:field xpath="mstns:K_UKS" />
    </xs:unique>
    <xs:unique name="dtUksKatSem_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtUksKatSem" />
      <xs:field xpath="mstns:K_UKS_KAT_SEM" />
    </xs:unique>
    <xs:unique name="dtUksKons_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtUksKons" />
      <xs:field xpath="mstns:K_UKS_KONS" />
    </xs:unique>
    <xs:unique name="dtUksPatr_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtUksPatr" />
      <xs:field xpath="mstns:K_UKS_PATR" />
    </xs:unique>
    <xs:unique name="dtUksChelder_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtUksChelder" />
      <xs:field xpath="mstns:K_UKS_CHELDER" />
    </xs:unique>
    <xs:unique name="dtSostavSemyiUks_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtSostavSemyiUks" />
      <xs:field xpath="mstns:K_SOSTAV_SEMYI" />
    </xs:unique>
    <xs:unique name="dtKlient_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtKlient" />
      <xs:field xpath="mstns:K_KLIENT" />
    </xs:unique>
    <xs:unique name="dtKpoSpis_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtKpoSpis" />
      <xs:field xpath="mstns:K_KPO" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="dtUks_dtAdr" msdata:parent="dtUKS" msdata:child="dtAdr" msdata:parentkey="K_ADR" msdata:childkey="K_ADR" msprop:Generator_UserRelationName="dtUks_dtAdr" msprop:Generator_RelationVarName="relationdtUks_dtAdr" msprop:Generator_UserChildTable="dtAdr" msprop:Generator_UserParentTable="dtUKS" msprop:Generator_ParentPropName="dtUKSRow" msprop:Generator_ChildPropName="GetdtAdrRows" />
      <msdata:Relationship name="dtUKS_dtUksKatSem" msdata:parent="dtUKS" msdata:child="dtUksKatSem" msdata:parentkey="K_UKS" msdata:childkey="K_UKS" msprop:Generator_UserRelationName="dtUKS_dtUksKatSem" msprop:Generator_RelationVarName="relationdtUKS_dtUksKatSem" msprop:Generator_UserChildTable="dtUksKatSem" msprop:Generator_UserParentTable="dtUKS" msprop:Generator_ParentPropName="dtUKSRow" msprop:Generator_ChildPropName="GetdtUksKatSemRows" />
      <msdata:Relationship name="dtUKS_dtSostavSemyiUks" msdata:parent="dtUKS" msdata:child="dtSostavSemyiUks" msdata:parentkey="K_UKS" msdata:childkey="K_UKS" msprop:Generator_UserRelationName="dtUKS_dtSostavSemyiUks" msprop:Generator_RelationVarName="relationdtUKS_dtSostavSemyiUks" msprop:Generator_UserChildTable="dtSostavSemyiUks" msprop:Generator_UserParentTable="dtUKS" msprop:Generator_ParentPropName="dtUKSRow" msprop:Generator_ChildPropName="GetdtSostavSemyiUksRows" />
      <msdata:Relationship name="dtUKS_dtKlient" msdata:parent="dtUKS" msdata:child="dtKlient" msdata:parentkey="K_UKS" msdata:childkey="K_UKS" msprop:Generator_UserRelationName="dtUKS_dtKlient" msprop:Generator_RelationVarName="relationdtUKS_dtKlient" msprop:Generator_UserChildTable="dtKlient" msprop:Generator_UserParentTable="dtUKS" msprop:Generator_ParentPropName="dtUKSRow" msprop:Generator_ChildPropName="GetdtKlientRows" />
      <msdata:Relationship name="dtUKS_dtKpoSpis" msdata:parent="dtUKS" msdata:child="dtKpoSpis" msdata:parentkey="K_UKS" msdata:childkey="K_UKS" msprop:Generator_UserRelationName="dtUKS_dtKpoSpis" msprop:Generator_RelationVarName="relationdtUKS_dtKpoSpis" msprop:Generator_UserChildTable="dtKpoSpis" msprop:Generator_UserParentTable="dtUKS" msprop:Generator_ParentPropName="dtUKSRow" msprop:Generator_ChildPropName="GetdtKpoSpisRows" />
      <msdata:Relationship name="dtUKS_dtUksPatr" msdata:parent="dtUKS" msdata:child="dtUksPatr" msdata:parentkey="K_UKS" msdata:childkey="K_UKS" msprop:Generator_UserRelationName="dtUKS_dtUksPatr" msprop:Generator_RelationVarName="relationdtUKS_dtUksPatr" msprop:Generator_UserChildTable="dtUksPatr" msprop:Generator_UserParentTable="dtUKS" msprop:Generator_ParentPropName="dtUKSRow" msprop:Generator_ChildPropName="GetdtUksPatrRows" />
      <msdata:Relationship name="dtUKS_dtUksChelder" msdata:parent="dtUKS" msdata:child="dtUksChelder" msdata:parentkey="K_UKS" msdata:childkey="K_UKS" msprop:Generator_UserRelationName="dtUKS_dtUksChelder" msprop:Generator_RelationVarName="relationdtUKS_dtUksChelder" msprop:Generator_UserChildTable="dtUksChelder" msprop:Generator_UserParentTable="dtUKS" msprop:Generator_ParentPropName="dtUKSRow" msprop:Generator_ChildPropName="GetdtUksChelderRows" />
      <msdata:Relationship name="dtUKS_dtbUksKons" msdata:parent="dtUKS" msdata:child="dtUksKons" msdata:parentkey="K_UKS" msdata:childkey="K_UKS" msprop:Generator_UserRelationName="dtUKS_dtbUksKons" msprop:Generator_RelationVarName="relationdtUKS_dtbUksKons" msprop:Generator_UserChildTable="dtUksKons" msprop:Generator_UserParentTable="dtUKS" msprop:Generator_ParentPropName="dtUKSRow" msprop:Generator_ChildPropName="GetdtUksKonsRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>